home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / runs.sql < prev    next >
Text File  |  2000-05-12  |  1KB  |  32 lines
  1. /* RCSVER $Id: runs.sql,v 1.4 2000-01-25 16:35:02-06 randy Exp $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        runs.sql
  6. * Date:        12/28/1998
  7. * memo:        Randy Wood
  8. * Description:    Create the runs table. This table contains all runs defined
  9. *        in the system.
  10. * Changes:
  11. ************************************************************************* */
  12. CREATE TABLE runs
  13. (
  14.     routeid    NUMBER(38),    /* associated route */
  15.     id    NUMBER(38),    /* ID of this run */
  16.     time    VARCHAR2(5),    /* Time of run HH:MM */
  17.     day    NUMBER(1),    /* Day of week:           */
  18.                 /* All (Sat-Sun):     0 */
  19.                 /* Sun:            1 */
  20.                 /* Mon:            2 */
  21.                 /* Tues:        3 */
  22.                 /* Wed:            4 */
  23.                 /* Thurs:        5 */
  24.                 /* Fri:            6 */
  25.                 /* Sat:            7 */
  26.                 /* Weekend (Sat/Sun):    8 */
  27.                 /* Weekday (Mon-Fri):    9 */
  28.     descr    VARCHAR2(30),    /* Description of this run */
  29.     config_num    NUMBER(38),
  30.     CONSTRAINT pk_runs PRIMARY KEY (routeid, id, config_num)
  31. );
  32.